// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   GetWorkflow.java

package include.nseer_cookie;

import include.nseer_db.nseer_db_backup;
import include.nseer_db.nseer_db_backup1;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class GetWorkflow
{

	public GetWorkflow()
	{
	}

	public static List getList(nseer_db_backup1 db, String table_name, String type_id)
	{
		List rsList = new ArrayList();
		String elem[] = new String[3];
		try
		{
			String sql = (new StringBuilder("select id,describe1,describe2 from ")).append(table_name).append(" where type_id='").append(type_id).append("'").toString();
			for (ResultSet rset = db.executeQuery(sql); rset.next(); rsList.add(elem))
			{
				elem = new String[3];
				elem[0] = rset.getString("id");
				elem[1] = rset.getString("describe1");
				elem[2] = rset.getString("describe2");
			}

		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
		return rsList;
	}

	public static List getList(nseer_db_backup db, String table_name, String type_id)
	{
		List rsList = new ArrayList();
		String elem[] = new String[3];
		try
		{
			String sql = (new StringBuilder("select id,describe1,describe2 from ")).append(table_name).append(" where type_id='").append(type_id).append("'").toString();
			for (ResultSet rset = db.executeQuery(sql); rset.next(); rsList.add(elem))
			{
				elem = new String[3];
				elem[0] = rset.getString("id");
				elem[1] = rset.getString("describe1");
				elem[2] = rset.getString("describe2");
			}

		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
		return rsList;
	}
}
